trees
406 rows where qSpecies_id = 47 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713 | 38369 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 5 | Permit Number 40431 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | 1 | 8 | 3 | 56 | 35 | |
1399 | 185502 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 56 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | 1 | 8 | 3 | 29491 | 35 | |||
2126 | 191407 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 7 | Front Yard : Yard | Tree | Private 2 | 12 | 6016225.71134 | 2100306.15132 | 37.747951477381 | -122.386639933312 | (37.747951477381, -122.386639933312) | 3 | 8 | 58 | 1 | |||||
2211 | 129471 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.400829384367 | (37.8023912773999, -122.400829384367) | 3 | 1 | 10 | 28860 | 6 | ||||
2561 | 50575 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1347 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | 0 | Permit Number 47190 | 5983353.97136461 | 2105974.76120709 | 37.7616412492229 | -122.50072631562 | (37.7616412492229, -122.50072631562) | 1 | 8 | 3 | 56 | 35 | |
3158 | 44124 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | 11 | 6 | 2 | 55 | 26 | |||
4229 | 80358 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6011201.39619 | 2088230.44969 | 37.7145146953757 | -122.403164591892 | (37.7145146953757, -122.403164591892) | 10 | 7 | 8 | 309 | 39 | |||
4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
5099 | 261940 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Verna St | 5 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
8913 | 50707 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1658 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2004 12:00:00 AM | 5 | Permit Number 47266 | 5983788.66504778 | 2103867.70402192 | 37.75588137239 | -122.499067221884 | (37.75588137239, -122.499067221884) | 1 | 8 | 3 | 56 | 35 | |
9451 | 84120 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011186.92342 | 2088226.0732 | 37.7145018701492 | -122.403214308206 | (37.7145018701492, -122.403214308206) | 10 | 7 | 8 | 309 | 39 | |||
10441 | 191402 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 8 | Front Yard : Yard | Tree | Private 2 | 7 | 6010700.42675 | 2107913.45144 | 37.7685319866755 | -122.406282136733 | (37.7685319866755, -122.406282136733) | 8 | 4 | 8 | 28853 | 19 | ||||
13132 | 207127 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | 1 | 8 | 4 | 64 | 40 | |||
13168 | 48530 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2251 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | 6 | Permit Number 45852 | 5988214.95937948 | 2099991.18132471 | 37.7454961303111 | -122.483475662249 | (37.7454961303111, -122.483475662249) | 1 | 8 | 3 | 29491 | 35 | |
13174 | 68069 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1993 12:00:00 AM | Permit Number 31806 | 5993313.66059206 | 2103207.09024288 | 37.7546216328473 | -122.466078949095 | (37.7546216328473, -122.466078949095) | 1 | 8 | 4 | 56 | 12 | ||
13250 | 45430 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
13849 | 117428 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | |||||||||||||
14177 | 129468 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | 5 | 1 | 1 | 28858 | 32 | ||||
16464 | 207116 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 5992178.8337 | 2088240.41516 | 37.7134613608383 | -122.468914357628 | (37.7134613608383, -122.468914357628) | 9 | 8 | 6 | 64 | 24 | ||||
16955 | 191397 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6010751.13717 | 2107916.66974 | 37.768543659889 | -122.406106959582 | (37.768543659889, -122.406106959582) | 8 | 4 | 8 | 28853 | 19 | ||||
17241 | 186756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | 1 | 8 | 3 | 56 | 35 | |||
18160 | 79486 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | 1 | 8 | 3 | 29491 | 35 | |
19390 | 47850 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1342 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 7 | Permit Number 45609 | 5983405.04544412 | 2106002.56953842 | 37.7617206013965 | -122.500551730195 | (37.7617206013965, -122.500551730195) | 1 | 8 | 3 | 56 | 35 | |
19751 | 38367 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4245 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 5 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | 1 | 8 | 3 | 56 | 35 | |
19861 | 207114 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 23 | 5992175.21623 | 2088282.16276 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | 9 | 8 | 6 | 64 | 24 | ||||
20037 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 47 | 155 Winston Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990788 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | 9 | 8 | 4 | 64 | 40 | |||||
20311 | 129474 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | 3 | 1 | 10 | 28860 | 6 | ||||
21677 | 51414 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1531 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 0 | Permit Number 47738 | 5988357.88494646 | 2104888.81015522 | 37.7589520258954 | -122.48334041038 | (37.7589520258954, -122.48334041038) | 1 | 8 | 3 | 56 | 35 | |
22890 | 50289 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
23023 | 185776 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2113 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987480.2363 | 2102327.5294 | 37.7518683261067 | -122.486187667743 | (37.7518683261067, -122.486187667743) | 1 | 8 | 3 | 29491 | 35 | |||
24415 | 119095 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 6700 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5982534.89521 | 2109675.70682 | 37.7717548615052 | -122.503833231018 | (37.7717548615052, -122.503833231018) | 11 | 6 | 2 | 55 | 26 | |||
24427 | 207105 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995373.14858 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | 9 | 8 | 4 | 28861 | 24 | |||
24972 | 191392 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6011311.05886 | 2104374.20224 | 37.7588481426559 | -122.403920910926 | (37.7588481426559, -122.403920910926) | 10 | 3 | 8 | 28856 | 29 | ||||
25754 | 47111 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45095 | 6007076.38254046 | 2097931.15674799 | 37.7409195061747 | -122.418109646545 | (37.7409195061747, -122.418109646545) | 2 | 7 | 7 | 28859 | 2 |
25781 | 207137 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 103 | : | Tree | Private 2 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | 9 | 8 | 4 | 64 | 40 | |||
26539 | 207135 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991243.40911 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | 9 | 8 | 4 | 64 | 40 | |||
26749 | 31667 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2571 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | Permit Number 35175 | 5981777.56166178 | 2097600.02639588 | 37.7385539042174 | -122.505557573977 | (37.7385539042174, -122.505557573977) | 1 | 8 | 3 | 29491 | 35 | ||
27854 | 185961 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2001 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984861.3455 | 2101337.8929 | 37.7489980727428 | -122.495171051634 | (37.7489980727428, -122.495171051634) | 1 | 8 | 3 | 29491 | 35 | |||
28693 | 191372 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011446.77315 | 2104664.66226 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | 10 | 3 | 8 | 28856 | 29 | |||
28788 | 50114 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46839 | 5992244.12505327 | 2098460.15223335 | 37.7415260004029 | -122.469432140867 | (37.7415260004029, -122.469432140867) | 1 | 8 | 4 | 29491 | 40 | ||
29184 | 176980 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5999548.76247 | 2089280.82364 | 37.7167411370713 | -122.443516055124 | (37.7167411370713, -122.443516055124) | 9 | 7 | 6 | 28861 | 25 | |||
29255 | 176982 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5999995.5387 | 2089705.60981 | 37.7179329735202 | -122.442002247903 | (37.7179329735202, -122.442002247903) | 9 | 7 | 6 | 28861 | 25 | |||
30167 | 207101 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990477.30542 | 2106226.48097 | 37.7627480320102 | -122.476108237903 | (37.7627480320102, -122.476108237903) | 1 | 8 | 3 | 56 | 12 | |||
30568 | 129464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | 13 | 9 | 1 | 28858 | 27 | |||
31184 | 218289 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5991265.02617 | 2095485.25519 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | 1 | 8 | 4 | 64 | 40 | ||||
32588 | 63441 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 299 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 24028 | 6008993.82853707 | 2096920.83270323 | 37.738253113659 | -122.411408443517 | (37.738253113659, -122.411408443517) | 10 | 7 | 7 | 28859 | 2 | ||
32735 | 40449 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 255 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47061 | 6008102.60669454 | 2097399.44811028 | 37.7395172589666 | -122.414523716357 | (37.7395172589666, -122.414523716357) | 2 | 7 | 7 | 28859 | 2 | ||
33940 | 129485 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.401633643571 | (37.803343726885, -122.401633643571) | 3 | 1 | 10 | 28860 | 6 | ||||
34167 | 69291 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 830 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33363 | 5991479.92264349 | 2102518.55863113 | 37.7526251419757 | -122.472370253301 | (37.7526251419757, -122.472370253301) | 1 | 8 | 4 | 56 | 12 | ||
34278 | 181438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | 1 | 8 | 3 | 56 | 35 | |||
34911 | 185504 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 58 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.494105581845 | (37.7420078978362, -122.494105581845) | 1 | 8 | 3 | 29491 | 35 | |||
36093 | 207107 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 89 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992169.55859 | 2088419.40871 | 37.7139522980308 | -122.468959433443 | (37.7139522980308, -122.468959433443) | 9 | 8 | 6 | 64 | 24 | ||||
36450 | 247870 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 6009721.06953 | 2098395.0417 | 37.7423417348977 | -122.408997980481 | (37.7423417348977, -122.408997980481) | 10 | 7 | 7 | 28859 | 2 | ||||
36662 | 121603 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 749 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6012453.25739 | 2104452.2107 | 37.7591260835233 | -122.399976111225 | (37.7591260835233, -122.399976111225) | 10 | 3 | 8 | 28856 | 29 | |||
37486 | 46399 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2110 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 5 | Permit Number 44629 | 5981721.80383178 | 2100709.75793181 | 37.7470890826019 | -122.505980852245 | (37.7470890826019, -122.505980852245) | 1 | 8 | 3 | 29491 | 35 | |
37655 | 207106 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Tara St | 2 | : | Tree | Private 2 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | 9 | 8 | 6 | 28861 | 24 | |||
40068 | 31575 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1922 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35114 | 5989431.17806618 | 2102257.22974077 | 37.7517888142139 | -122.479435972521 | (37.7517888142139, -122.479435972521) | 1 | 8 | 3 | 29491 | 35 | ||
40263 | 227676 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 427 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | 2 | 7 | 5 | 63 | 22 | ||||
40373 | 186512 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 13 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | 1 | 8 | 3 | 56 | 35 | |||
40962 | 183209 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4212 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5982952.5112 | 2098143.3306 | 37.7401147458032 | -122.501535410067 | (37.7401147458032, -122.501535410067) | 1 | 8 | 3 | 29491 | 35 | |||
42446 | 52384 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 36TA MARINA Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48509 | 6005730.58900637 | 2097520.8738626 | 37.7397171218166 | -122.422733759035 | (37.7397171218166, -122.422733759035) | 2 | 7 | 7 | 28859 | 2 | ||
42527 | 207128 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 5991324.62806 | 2095649.61894 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | 1 | 8 | 4 | 64 | 40 | |||
43157 | 227687 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.451424345184 | (37.7653509793933, -122.451424345184) | 15 | 5 | 11 | 29492 | 9 | |||
43896 | 38348 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1607 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 0 | Permit Number 40415 | 5981863.96536039 | 2104143.69244361 | 37.7565260672017 | -122.505743805317 | (37.7565260672017, -122.505743805317) | 1 | 8 | 3 | 56 | 35 | |
43944 | 184307 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | 1 | 8 | 3 | 56 | 35 | |||
44818 | 191405 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 9 | Front Yard : Yard | Tree | Private 2 | 8 | 6016216.75475 | 2100305.37684 | 37.7479488549636 | -122.386670851103 | (37.7479488549636, -122.386670851103) | 3 | 8 | 58 | 1 | |||||
45957 | 191393 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011318.33835 | 2104379.19174 | 37.758862249405 | -122.403896086039 | (37.758862249405, -122.403896086039) | 10 | 3 | 8 | 28856 | 29 | ||||
46544 | 183430 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | 1 | 8 | 3 | 29491 | 35 | |||
46607 | 176987 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6002815.8897 | 2094148.38707 | 37.7302921639516 | -122.432570708688 | (37.7302921639516, -122.432570708688) | 9 | 7 | 5 | 28861 | 25 | |||
46709 | 191390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | 10 | 3 | 8 | 28856 | 29 | ||||
47586 | 57377 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3505 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006157.87748572 | 2102561.9990288 | 37.7535830045092 | -122.421614323469 | (37.7535830045092, -122.421614323469) | 2 | 4 | 5 | 28859 | 19 | ||
47603 | 218294 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5991183.55146 | 2095353.09261 | 37.7329334566034 | -122.472872697534 | (37.7329334566034, -122.472872697534) | 1 | 8 | 4 | 64 | 40 | ||||
47779 | 138264 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 32 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.446995936272 | (37.7823276740968, -122.446995936272) | 15 | 5 | 1 | 54 | 16 | |||
47837 | 227688 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.7407809344798 | -122.41570987722 | (37.7407809344798, -122.41570987722) | 2 | 7 | 7 | 28859 | 2 | |||
49514 | 227681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997959.25406 | 2106183.43699 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | 15 | 5 | 11 | 29492 | 9 | |||
49589 | 186745 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | 1 | 8 | 3 | 56 | 35 | |||
49732 | 186510 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 11 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.7591962518414 | -122.509142853237 | (37.7591962518414, -122.509142853237) | 1 | 8 | 3 | 56 | 35 | |||
50220 | 18882 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6003557.0695 | 2115907.13274 | 37.7900784748972 | -122.43156114415 | (37.7900784748972, -122.43156114415) | 13 | 9 | 1 | 29490 | 27 | |||
50593 | 83239 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
50732 | 253463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
51510 | 33405 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 390 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1998 12:00:00 AM | Permit Number 40744 | 5992420.09105205 | 2094203.06284675 | 37.7298472692889 | -122.468514054616 | (37.7298472692889, -122.468514054616) | 9 | 8 | 4 | 59 | 40 | ||
52711 | 207102 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990480.89082 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | 1 | 8 | 3 | 56 | 12 | |||
53088 | 33391 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 129 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37510 | 5993545.21642202 | 2093774.31911417 | 37.7287349718633 | -122.464593277929 | (37.7287349718633, -122.464593277929) | 9 | 8 | 4 | 59 | 40 | ||
53776 | 191401 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 7 | Front Yard : Yard | Tree | Private 2 | 8 | 6010711.19096 | 2107913.74245 | 37.7685333878424 | -122.406244924566 | (37.7685333878424, -122.406244924566) | 8 | 4 | 8 | 28853 | 19 | ||||
54058 | 129472 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | 3 | 1 | 10 | 28860 | 6 | ||||
54078 | 52269 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48434 | 6005520.49766263 | 2101354.49181367 | 37.7502315077339 | -122.423732674774 | (37.7502315077339, -122.423732674774) | 2 | 4 | 5 | 28859 | 19 | ||
54154 | 129479 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012506.13221 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | 3 | 1 | 10 | 28860 | 6 | ||||
54525 | 191388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 40 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011282.56063 | 2104153.62595 | 37.7582408970175 | -122.40400394893 | (37.7582408970175, -122.40400394893) | 10 | 3 | 8 | 28856 | 29 | |||
54666 | 31185 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34883 | 5992147.8527206 | 2089880.99524616 | 37.7179642061069 | -122.469140766842 | (37.7179642061069, -122.469140766842) | 9 | 8 | 6 | 64 | 24 | ||
55330 | 186759 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | 1 | 8 | 3 | 56 | 35 | |||
55583 | 191391 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.403937978273 | (37.7588597960547, -122.403937978273) | 10 | 3 | 8 | 28856 | 29 | ||||
56036 | 909 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003163.68633 | 2094174.89484 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | 9 | 7 | 6 | 28861 | 25 | |||
56247 | 35417 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
56832 | 227680 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003988.60954 | 2099295.31119 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | 2 | 7 | 5 | 63 | 22 | |||
56934 | 191400 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010721.65743 | 2107914.21049 | 37.7685352584272 | -122.406208754734 | (37.7685352584272, -122.406208754734) | 8 | 4 | 8 | 28853 | 19 | ||||
57475 | 45437 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44224 | 5993813.83621392 | 2092411.23769418 | 37.7250077648019 | -122.463565764966 | (37.7250077648019, -122.463565764966) | 9 | 8 | 4 | 59 | 40 | ||
58446 | 183252 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5980914.4873 | 2106074.217 | 37.7617708050911 | -122.509170734828 | (37.7617708050911, -122.509170734828) | 1 | 8 | 3 | 56 | 35 | |||
58696 | 119085 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 886 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5982037.396 | 2109722.65545 | 37.7718545033558 | -122.505557564286 | (37.7718545033558, -122.505557564286) | 11 | 6 | 2 | 55 | 26 | |||
59472 | 52106 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | 9 | 7 | 4 | 59 | 40 | ||
59598 | 191367 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 548 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6011194.69766 | 2105791.52689 | 37.7627332975312 | -122.404423107658 | (37.7627332975312, -122.404423107658) | 8 | 3 | 8 | 28856 | 29 |
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) );