trees
296 rows where Fire Prevention Districts = 10 and qSpecies_id = 5 sorted by YCoord descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
160679 | 101685 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 12x9 | 6013519.41723 | 2105388.32273 | 37.7617558261822 | -122.396354408248 | (37.7617558261822, -122.396354408248) | 10 | 3 | 8 | 28856 | 29 | |||
62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
97684 | 115557 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
25806 | 47316 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2524 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | 10 | 4 | 8 | 28859 | 19 | ||
161298 | 47317 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | 10 | 4 | 8 | 28859 | 19 | |||
138379 | 222901 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010350.92768 | 2105070.60578 | 37.7607066222297 | -122.407290598708 | (37.7607066222297, -122.407290598708) | 10 | 4 | 8 | 28859 | 19 | |||
148016 | 222902 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6010304.7702 | 2105067.63235 | 37.760695874438 | -122.407450027813 | (37.760695874438, -122.407450027813) | 10 | 4 | 8 | 28859 | 19 | |||
33787 | 2545 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1590X Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.7449863439757 | -122.386832330586 | (37.7449863439757, -122.386832330586) | 10 | 3 | 8 | 58 | 1 | ||
109158 | 2546 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1590X Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.7449863439757 | -122.386832330586 | (37.7449863439757, -122.386832330586) | 10 | 3 | 8 | 58 | 1 | |||
117844 | 188482 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 3 | : | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | 10 | 3 | 8 | 58 | 1 | ||
50667 | 2542 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016211.040056 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | 10 | 3 | 8 | 58 | 1 | |||
49970 | 2531 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.386392104106 | (37.7447358261247, -122.386392104106) | 10 | 3 | 8 | 58 | 1 | |||
190873 | 2530 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.386392104106 | (37.7447358261247, -122.386392104106) | 10 | 3 | 8 | 58 | 1 | |||
70301 | 2533 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016180.33193 | 2099126.30756 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | 10 | 3 | 8 | 58 | 1 | |||
129151 | 188481 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 10 | : | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.7447010172388 | -122.386302728 | (37.7447010172388, -122.386302728) | 10 | 3 | 8 | 58 | 1 | ||
85869 | 2534 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.7446815361299 | -122.386659150015 | (37.7446815361299, -122.386659150015) | 10 | 3 | 8 | 58 | 1 | |||
139429 | 2541 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016218.6051359 | 2099112.8628025 | 37.7446745598911 | -122.386581311559 | (37.7446745598911, -122.386581311559) | 10 | 3 | 8 | 58 | 1 | |||
106760 | 2535 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016210.73833 | 2099105.12284 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | 10 | 3 | 8 | 58 | 1 | |||
155081 | 2536 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016262.66893 | 2099065.69559 | 37.744547487686 | -122.38642565812 | (37.744547487686, -122.38642565812) | 10 | 3 | 8 | 58 | 1 | |||
79778 | 2524 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449 | 2099041 | 37.7444899913278 | -122.385779635787 | (37.7444899913278, -122.385779635787) | 10 | 3 | 8 | 58 | 1 | ||
168339 | 2544 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6016440 | 2099034 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | 10 | 3 | 8 | 58 | 1 | |||
83022 | 2522 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.0270005 | 2099019.0971083 | 37.7444240410894 | -122.386141087772 | (37.7444240410894, -122.386141087772) | 10 | 3 | 8 | 58 | 1 | |||
81257 | 2540 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | 10 | 3 | 8 | 58 | 1 | |||
117722 | 2513 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016387.51247 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | 10 | 3 | 8 | 58 | 1 | |||
120474 | 2514 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | 10 | 3 | 8 | 58 | 1 | |||
179562 | 2526 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | 10 | 3 | 8 | 58 | 1 | |||
149727 | 2515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | 10 | 3 | 8 | 58 | 1 | |||
41334 | 2516 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016465.84234 | 2098914.75953 | 37.7441442928392 | -122.38571260096 | (37.7441442928392, -122.38571260096) | 10 | 3 | 8 | 58 | 1 | |||
71087 | 189833 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 2 | : | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | 10 | 3 | 8 | 58 | 1 | ||
5811 | 2517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | 10 | 3 | 8 | 58 | 1 | |||
40094 | 2518 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016498.61775 | 2098890.19219 | 37.7440786495081 | -122.385597557904 | (37.7440786495081, -122.385597557904) | 10 | 3 | 8 | 58 | 1 | |||
122418 | 2519 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.385534806811 | (37.7440450526322, -122.385534806811) | 10 | 3 | 8 | 58 | 1 | |||
84076 | 2520 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) | 10 | 3 | 8 | 58 | 1 | |||
151412 | 2504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | 10 | 3 | 8 | 58 | 1 | |||
161350 | 2503 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.7439716553617 | -122.384993582204 | (37.7439716553617, -122.384993582204) | 10 | 3 | 8 | 58 | 1 | |||
123783 | 2521 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016567.75907 | 2098840.98498 | 37.7439473619958 | -122.385355052105 | (37.7439473619958, -122.385355052105) | 10 | 3 | 8 | 58 | 1 | |||
192875 | 2502 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016691.63378 | 2098834.3481 | 37.743935990944 | -122.38492625536 | (37.743935990944, -122.38492625536) | 10 | 3 | 8 | 58 | 1 | |||
161276 | 188483 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016580.58877 | 2098830.37302 | 37.7439189335051 | -122.385309950204 | (37.7439189335051, -122.385309950204) | 10 | 3 | 8 | 58 | 1 | |||
42634 | 2501 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016709.08958 | 2098828.16093 | 37.7439199677279 | -122.384865465686 | (37.7439199677279, -122.384865465686) | 10 | 3 | 8 | 58 | 1 | |||
126809 | 2500 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016728.12134 | 2098825.14197 | 37.7439127309012 | -122.384799447345 | (37.7439127309012, -122.384799447345) | 10 | 3 | 8 | 58 | 1 | |||
124745 | 2499 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016750.97009 | 2098814.51662 | 37.7438848195436 | -122.384719700863 | (37.7438848195436, -122.384719700863) | 10 | 3 | 8 | 58 | 1 | |||
175245 | 2498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016761.82696 | 2098799.80324 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | 10 | 3 | 8 | 58 | 1 | |||
142543 | 188484 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016633.99026 | 2098788.07165 | 37.7438057367534 | -122.38512235163 | (37.7438057367534, -122.38512235163) | 10 | 3 | 8 | 58 | 1 | |||
35835 | 2509 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
55055 | 2507 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
104002 | 2512 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
123202 | 2510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
179658 | 2505 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
191865 | 2511 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
24789 | 188485 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016660.6215 | 2098754.7402 | 37.7437156885266 | -122.385027944407 | (37.7437156885266, -122.385027944407) | 10 | 3 | 8 | 58 | 1 | |||
100284 | 3652 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 88 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017348.88964 | 2098746.4497 | 37.7437309716031 | -122.382647477613 | (37.7437309716031, -122.382647477613) | 10 | 3 | 8 | 58 | 1 | ||
119961 | 188486 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6016667.7961 | 2098739.5766 | 37.7436744492327 | -122.385002079878 | (37.7436744492327, -122.385002079878) | 10 | 3 | 8 | 58 | 1 | |||
125723 | 188487 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016679.39003 | 2098723.90702 | 37.7436320650598 | -122.384960899022 | (37.7436320650598, -122.384960899022) | 10 | 3 | 8 | 58 | 1 | |||
75632 | 188488 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 8 | : | Tree | Private 2 | 8 | Width 4ft | 6016697.4652 | 2098710.93051 | 37.7435974339762 | -122.384897495043 | (37.7435974339762, -122.384897495043) | 10 | 3 | 8 | 58 | 1 | |||
42308 | 3639 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180002 | -122.381933568796 | (37.743238180002, -122.381933568796) | 10 | 3 | 8 | 58 | 1 | ||
163469 | 3627 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | 10 | 3 | 8 | 58 | 1 | ||
43361 | 14928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
57622 | 14925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
77385 | 14926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
82733 | 14930 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
102144 | 14932 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
102602 | 14927 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
164547 | 14929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
167263 | 14924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
177736 | 14931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
75614 | 189900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6016469.43957 | 2098386.38148 | 37.7426936737758 | -122.385663344212 | (37.7426936737758, -122.385663344212) | 10 | 3 | 8 | 58 | 1 | |||
29463 | 189899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016506.94741 | 2098386.01279 | 37.7426947367801 | -122.385533625971 | (37.7426947367801, -122.385533625971) | 10 | 3 | 8 | 58 | 1 | |||
158664 | 189901 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6016452.46192 | 2098385.21634 | 37.7426895350994 | -122.385721967406 | (37.7426895350994, -122.385721967406) | 10 | 3 | 8 | 58 | 1 | |||
48636 | 16511 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016438.27303 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | 10 | 3 | 8 | 58 | 1 | |||
13958 | 262096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | ||||
75654 | 189902 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | |||
120815 | 93114 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.71109 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | 10 | 3 | 8 | 58 | 1 | |
107870 | 16512 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016415.99739 | 2098380.53365 | 37.7426746595649 | -122.38584772612 | (37.7426746595649, -122.38584772612) | 10 | 3 | 8 | 58 | 1 | |||
65447 | 93113 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.49318 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | 10 | 3 | 8 | 58 | 1 | |
145080 | 16513 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016404.80629 | 2098376.61978 | 37.7426632935725 | -122.385886149327 | (37.7426632935725, -122.385886149327) | 10 | 3 | 8 | 58 | 1 | |||
78824 | 16520 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
112108 | 16517 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
128143 | 16515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
136729 | 16519 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
169044 | 16510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
173950 | 16516 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
163591 | 93112 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.385343417566 | (37.7426681627043, -122.385343417566) | 10 | 3 | 8 | 58 | 1 | |
163249 | 189904 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6016400.23461 | 2098374.6941 | 37.7426577530525 | -122.385901822825 | (37.7426577530525, -122.385901822825) | 10 | 3 | 8 | 58 | 1 | |||
141218 | 93111 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.7426554067123 | -122.385264779961 | (37.7426554067123, -122.385264779961) | 10 | 3 | 8 | 58 | 1 | |
19053 | 153989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016386.30028 | 2098368.17483 | 37.7426390813321 | -122.385949549827 | (37.7426390813321, -122.385949549827) | 10 | 3 | 8 | 58 | 1 | |||
190306 | 93110 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.54888 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | 10 | 3 | 8 | 58 | 1 | |
24626 | 93109 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.35417 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | 10 | 3 | 8 | 58 | 1 | |
72425 | 189898 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6016641.64949 | 2098357.67933 | 37.7426243909147 | -122.385065886799 | (37.7426243909147, -122.385065886799) | 10 | 3 | 8 | 58 | 1 | |||
175649 | 189897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016662.64586 | 2098353.63161 | 37.7426144381027 | -122.384993004817 | (37.7426144381027, -122.384993004817) | 10 | 3 | 8 | 58 | 1 | |||
65426 | 189896 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.384921425089 | (37.7426025436648, -122.384921425089) | 10 | 3 | 8 | 58 | 1 | |||
21954 | 189895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016704.91422 | 2098345.41637 | 37.7425942186412 | -122.384846279543 | (37.7425942186412, -122.384846279543) | 10 | 3 | 8 | 58 | 1 | |||
73224 | 16514 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016343.32243 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | 10 | 3 | 8 | 58 | 1 | |||
3688 | 189905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016340.3864 | 2098339.29531 | 37.7425572430226 | -122.386106295385 | (37.7425572430226, -122.386106295385) | 10 | 3 | 8 | 58 | 1 | |||
18347 | 189903 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016618 | 2098337 | 37.7425663014752 | -122.385146220096 | (37.7425663014752, -122.385146220096) | 10 | 3 | 8 | 58 | 1 | |||
16214 | 16506 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
73656 | 16503 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
100676 | 16500 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
102198 | 16504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
132298 | 16502 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
135231 | 16505 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );