trees
8,659 rows where qSpecies_id = 11 sorted by qLegalStatus_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29768 | 87422 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 6009092.517834 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | 7 | 10 | 9 | 28852 | 36 | ||||
63001 | 85312 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 1366 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6003535.85294 | 2112477.60862 | 37.7806606630436 | -122.431389631549 | (37.7806606630436, -122.431389631549) | 15 | 9 | 11 | 29490 | 41 | |||
127776 | 87423 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009092.517834 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | 7 | 10 | 9 | 28852 | 36 | ||
161715 | 85436 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 1397X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/17/2007 12:00:00 AM | 3 | 3x3 | Maintenance agreement ends 8/17/2010 | 6004184.830731 | 2113056.513958 | 37.782286952179 | -122.429185796304 | (37.782286952179, -122.429185796304) | 7 | 9 | 11 | 29490 | 41 |
176108 | 87410 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | ||
963 | 109935 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011302 | 2112245.5 | 37.7804604268654 | -122.404506314811 | (37.7804604268654, -122.404506314811) | 14 | 2 | 9 | 28853 | 34 | |
12295 | 108536 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 1036X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009831.24398 | 2112235.16984 | 37.7803497589148 | -122.409593644194 | (37.7803497589148, -122.409593644194) | 14 | 2 | 9 | 28853 | 34 | ||||
23173 | 109936 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011302 | 2112245.5 | 37.7804604268654 | -122.404506314811 | (37.7804604268654, -122.404506314811) | 14 | 2 | 9 | 28853 | 34 | |
26043 | 100060 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435 | 2112345 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | 14 | 2 | 9 | 28853 | 34 | |
52698 | 118340 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006507 | 2110162 | 37.7744705012603 | -122.420946535292 | (37.7744705012603, -122.420946535292) | 7 | 9 | 11 | 28852 | 10 | ||||
102447 | 100059 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435 | 2112345 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | 14 | 2 | 9 | 28853 | 34 | |
148956 | 32654 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011426.1069309 | 2112339.71009356 | 37.7807260408269 | -122.40408360027 | (37.7807260408269, -122.40408360027) | 14 | 2 | 9 | 28853 | 34 | |
168085 | 118341 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006507 | 2110162 | 37.7744705012603 | -122.420946535292 | (37.7744705012603, -122.420946535292) | 7 | 9 | 11 | 28852 | 10 | ||||
51620 | 26198 | Private 9 | Lophostemon confertus :: Brisbane Box 11 | 3830 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x4 | 6015747.5106038 | 2098323.3315623 | 37.742480578689 | -122.388155190044 | (37.742480578689, -122.388155190044) | 10 | 3 | 8 | 58 | 1 | |||
132854 | 25212 | Private 9 | Lophostemon confertus :: Brisbane Box 11 | 215X Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006420.22763 | 2110742.05634 | 37.7760583047566 | -122.421287897592 | (37.7760583047566, -122.421287897592) | 7 | 9 | 11 | 28852 | 10 | |||
80950 | 255115 | Property Tree 8 | Lophostemon confertus :: Brisbane Box 11 | 301X Chester Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
236 | 27345 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 664 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 4 | 4x4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
843 | 38804 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
958 | 36868 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
1017 | 46142 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
1036 | 82363 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1455 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49901 | 6007633.52614619 | 2107338.64546667 | 37.7667816713746 | -122.416849584537 | (37.7667816713746, -122.416849584537) | 8 | 4 | 7 | 28853 | 19 | ||
1183 | 47616 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
1602 | 45381 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
1665 | 47611 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | Permit Number 45444 | |||||||||||||
1676 | 84541 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 838 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51852 | 5986369.18358167 | 2110196.92433931 | 37.7734106873115 | -122.49060871536 | (37.7734106873115, -122.49060871536) | 11 | 6 | 2 | 55 | 26 | ||
2157 | 66537 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 17 Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1995 12:00:00 AM | Permit Number 29712 | 6000633.94026001 | 2105546.19436908 | 37.76146384633 | -122.440931323073 | (37.76146384633, -122.440931323073) | 15 | 5 | 5 | 28862 | 3 | ||
2283 | 49626 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152211th/10th Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46481 | |||||||||||||
2296 | 32307 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36882 | |||||||||||||
2310 | 91800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
2315 | 87492 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2085 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2010 12:00:00 AM | 3 | 3x3 | 6015789.87829 | 2105903.76161 | 37.7632971922443 | -122.388537703233 | (37.7632971922443, -122.388537703233) | 14 | 3 | 8 | 28856 | 29 | ||
2403 | 60302 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1200 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1982 12:00:00 AM | 3x3 | Permit Number 19869 | 5992068.87064248 | 2106619.25975245 | 37.7639186591654 | -122.470632238353 | (37.7639186591654, -122.470632238353) | 11 | 8 | 11 | 56 | 12 | ||
2484 | 20118 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 875X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 12 | 2X2 | 6003233.15229 | 2110304.12624 | 37.774675660821 | -122.432281545934 | (37.774675660821, -122.432281545934) | 15 | 9 | 11 | 29492 | 10 | ||
2552 | 42536 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.7724197439799 | -122.419692774816 | (37.7724197439799, -122.419692774816) | 8 | 2 | 9 | 28853 | 19 | ||
2611 | 52930 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 36 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48915 | 5999971.05699015 | 2092944.44477133 | 37.7268246780096 | -122.442319255194 | (37.7268246780096, -122.442319255194) | 9 | 7 | 6 | 28861 | 25 | ||
2630 | 47383 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1515 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | Permit Number 46367 | 6006307.07862293 | 2118296.63950756 | 37.7967949468883 | -122.422216159163 | (37.7967949468883, -122.422216159163) | 13 | 9 | 10 | 28858 | 32 | |||
2996 | 38797 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
3059 | 68742 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3926 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32663 | 6003444.16925552 | 2105388.01634751 | 37.7611891817503 | -122.431200618374 | (37.7611891817503, -122.431200618374) | 15 | 4 | 5 | 28862 | 3 | ||
3240 | 23833 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1302X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2008 12:00:00 AM | 3 | 3X3 | 6003750.8656173 | 2113176.0104319 | 37.7825904834742 | -122.43069565207 | (37.7825904834742, -122.43069565207) | 7 | 9 | 11 | 29490 | 41 | ||
3437 | 79 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 899 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3X3 | 6002864.3199934 | 2107660.1796498 | 37.7673951141913 | -122.433368437593 | (37.7673951141913, -122.433368437593) | 15 | 5 | 5 | 28862 | 3 | |||
3528 | 38666 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1998 12:00:00 AM | Permit Number 40586 | |||||||||||||
3783 | 47477 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
3835 | 42802 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | 8 | 4 | 5 | 28862 | 3 | |||
3958 | 29691 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | 9 | 7 | 8 | 309 | 39 | ||
4046 | 43411 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 536 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43154 | 6002822.07551999 | 2103890.28570644 | 37.7570415002259 | -122.433245151224 | (37.7570415002259, -122.433245151224) | 2 | 4 | 5 | 28862 | 3 | ||
4118 | 60587 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1596 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 3x3 | Permit Number 50372 | 6000129.25218727 | 2110962.46444115 | 37.7763068086663 | -122.443065816912 | (37.7763068086663, -122.443065816912) | 15 | 5 | 11 | 29492 | 16 | ||
4247 | 41540 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 775X 02nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42068 | 6015692.30699351 | 2111981.66601878 | 37.7799803743496 | -122.389299616981 | (37.7799803743496, -122.389299616981) | 6 | 2 | 9 | 28856 | 20 | |
4330 | 68743 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3929 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32664 | 6003434.71793969 | 2105335.41306872 | 37.761044210169 | -122.431229551523 | (37.761044210169, -122.431229551523) | 2 | 4 | 5 | 28862 | 3 | ||
4428 | 66790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2150 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53367 | 6006860.21214417 | 2118575.27175394 | 37.79759118503 | -122.420321971868 | (37.79759118503, -122.420321971868) | 5 | 9 | 10 | 28858 | 32 | ||
5074 | 22216 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4250X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6015384.98643 | 2097123.18461 | 37.7391651289337 | -122.389324913037 | (37.7391651289337, -122.389324913037) | 10 | 3 | 8 | 58 | 1 | ||
5351 | 108330 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 86 11TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
5589 | 39428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 290 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
5660 | 24445 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2251X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6015765.11922 | 2105348.0588 | 37.7617699797552 | -122.388584545263 | (37.7617699797552, -122.388584545263) | 10 | 3 | 8 | 28856 | 29 | ||
5759 | 47617 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
5896 | 68729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32645 | 5998785.51386128 | 2099959.35584866 | 37.7460183133905 | -122.446922200801 | (37.7460183133905, -122.446922200801) | 2 | 7 | 5 | 63 | 7 | |||
6184 | 64799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25798 | 6003587.23896685 | 2100132.28558533 | 37.7467662928737 | -122.430330814023 | (37.7467662928737, -122.430330814023) | 2 | 7 | 5 | 63 | 22 | ||
6231 | 46141 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
7036 | 38800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
7053 | 93534 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 325 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
7363 | 35440 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 | |||||||||||||
7573 | 64140 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 408 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24912 | 6003905.86029931 | 2098394.49493183 | 37.7420127636574 | -122.429105167098 | (37.7420127636574, -122.429105167098) | 2 | 7 | 5 | 63 | 22 | ||
7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
7619 | 35441 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 | |||||||||||||
7771 | 49688 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2235 NOTES) Hayes St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2003 12:00:00 AM | Permit Number 46511 | 5997175.15188937 | 2109805.23760487 | 37.7729604879505 | -122.453201252207 | (37.7729604879505, -122.453201252207) | 15 | 5 | 11 | 29492 | 16 | |||
7899 | 42795 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | 8 | 4 | 5 | 28862 | 3 | |||
7977 | 63890 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 165 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24599 | 6005777.74997654 | 2109961.71011831 | 37.7738794203064 | -122.423454911884 | (37.7738794203064, -122.423454911884) | 7 | 9 | 11 | 28852 | 10 | ||
8397 | 38801 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
8418 | 64139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 523 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24910 | 6003239.38144538 | 2098311.93722578 | 37.7417483289476 | -122.431403744863 | (37.7417483289476, -122.431403744863) | 2 | 7 | 5 | 63 | 7 | ||
8544 | 256668 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1835 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782601 | |||||||||||
8691 | 47618 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
8945 | 38806 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
9026 | 23835 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1302X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1990 12:00:00 AM | 20 | 3X3 | 6003750.8656173 | 2113176.0104319 | 37.7825904834742 | -122.43069565207 | (37.7825904834742, -122.43069565207) | 7 | 9 | 11 | 29490 | 41 | ||
9193 | 32309 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36882 | |||||||||||||
9292 | 46150 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
9367 | 83358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1160 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50875 | 5997390.75214654 | 2106213.86032098 | 37.7631118403797 | -122.452196286828 | (37.7631118403797, -122.452196286828) | 15 | 5 | 11 | 29492 | 9 | ||
9413 | 35439 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 | |||||||||||||
9458 | 84830 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 939 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | Permit No. 49222 | 6002944 | 2110261 | 37.7745408475216 | -122.433278698665 | (37.7745408475216, -122.433278698665) | 15 | 5 | 11 | 29492 | 10 | |||
9832 | 46143 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
10086 | 47615 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
10223 | 7769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
10415 | 43967 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43534 | 6006999.24602912 | 2112908.87547401 | 37.7820404937398 | -122.419438672428 | (37.7820404937398, -122.419438672428) | 7 | 9 | 9 | 28852 | 36 | |||
10531 | 84036 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 45 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50462 | 6001133.37697683 | 2103651.61212773 | 37.7562902176876 | -122.439068194619 | (37.7562902176876, -122.439068194619) | 2 | 4 | 5 | 28862 | 38 | ||
10617 | 49671 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2235 NOTES) Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2003 12:00:00 AM | Permit Number 46511 | 5997175.15188937 | 2109805.23760487 | 37.7729604879505 | -122.453201252207 | (37.7729604879505, -122.453201252207) | 15 | 5 | 11 | 29492 | 16 | |||
10657 | 29740 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 629 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775746 | 6009949.88308 | 2119458.12885 | 37.8001889103038 | -122.409693183014 | (37.8001889103038, -122.409693183014) | 3 | 1 | 10 | 308 | 23 | |
10777 | 35244 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
10962 | 39426 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.7733943405421 | -122.42743561187 | (37.7733943405421, -122.42743561187) | 7 | 9 | 11 | 28852 | 10 | |||
11164 | 64419 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 111 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25267 | 6003583.64860345 | 2097735.92139782 | 37.740186227283 | -122.430172299864 | (37.740186227283, -122.430172299864) | 2 | 7 | 5 | 63 | 7 | ||
11177 | 47475 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
11510 | 470 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2490 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009704.8170941 | 2102845.113501 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | 2 | 4 | 7 | 28859 | 19 | |||
11524 | 64282 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 411 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25086 | 6003895.1200055 | 2098341.81687307 | 37.7418675138214 | -122.429138548404 | (37.7418675138214, -122.429138548404) | 2 | 7 | 5 | 63 | 7 | ||
11762 | 62725 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 109 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/1986 12:00:00 AM | Permit Number 23071 | 6001085.93774818 | 2105743.30332199 | 37.7620307920739 | -122.439382183867 | (37.7620307920739, -122.439382183867) | 15 | 5 | 5 | 28862 | 3 | ||
11779 | 44518 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 100X TOWNSEND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2001 12:00:00 AM | 9 | 3x3 | Permit Number 43820 | 6015218.7 | 2112179.2 | 37.7804964903429 | -122.390951859139 | (37.7804964903429, -122.390951859139) | 6 | 2 | 9 | 28856 | 6 | |
11945 | 47610 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | Permit Number 45444 | |||||||||||||
12038 | 50316 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1055 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
12394 | 47612 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | Permit Number 45444 | |||||||||||||
12402 | 67521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 424 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31057 | 5997342.043029 | 2093839.69948247 | 37.7291326429008 | -122.451472187982 | (37.7291326429008, -122.451472187982) | 9 | 7 | 4 | 28861 | 40 | ||
12508 | 62227 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 228 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22352 | 6001110.06412505 | 2093217.52334826 | 37.7276393417973 | -122.438401301148 | (37.7276393417973, -122.438401301148) | 9 | 7 | 6 | 28861 | 25 | ||
12650 | 92885 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1366 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2009 12:00:00 AM | 3x3 | Permit Number 53100 | 6008075 | 2110545 | 37.7756103885853 | -122.415549628976 | (37.7756103885853, -122.415549628976) | 8 | 2 | 9 | 28853 | 34 | |
12744 | 35438 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 |
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) );