trees
5,599 rows where qSpecies_id = 38 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
157176 | 118688 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4645 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5981105.94918 | 2110928.32696 | 37.7751100630106 | -122.508868980798 | (37.7751100630106, -122.508868980798) | 11 | 6 | 2 | 55 | 26 | ||||
178113 | 90957 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4645 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981126.99481 | 2110929.9331 | 37.7751157135635 | -122.508796299887 | (37.7751157135635, -122.508796299887) | 11 | 6 | 2 | 55 | 26 | ||
62774 | 119137 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 539 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5981289.03563 | 2112044.01015 | 37.778184190679 | -122.50831848869 | (37.778184190679, -122.50831848869) | 11 | 6 | 2 | 55 | 26 | |||
176622 | 119139 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 549 47th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5981289.11687 | 2111973.60449 | 37.7779908823475 | -122.508312980233 | (37.7779908823475, -122.508312980233) | 11 | 6 | 2 | 55 | 26 | |||
181871 | 67264 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 549 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 9 | Permit Number 30731 | 5981289.18602 | 2111977.44312 | 37.7780014261654 | -122.50831302603 | (37.7780014261654, -122.50831302603) | 11 | 6 | 2 | 55 | 26 | |
104315 | 119138 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 545 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5981290.11106 | 2111996.02979 | 37.7780525141783 | -122.508311206048 | (37.7780525141783, -122.508311206048) | 11 | 6 | 2 | 55 | 26 | |||
50304 | 118875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 722 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981376.47847 | 2110796.96576 | 37.7747653270952 | -122.507923425807 | (37.7747653270952, -122.507923425807) | 11 | 6 | 2 | 55 | 26 | |||
124578 | 56079 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 722 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | 9 | Permit Number 12176 | 5981378.48876 | 2110785.71135 | 37.7747345442385 | -122.50791563652 | (37.7747345442385, -122.50791563652) | 11 | 6 | 2 | 55 | 26 | ||
29604 | 119129 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 559 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5981600.59908 | 2111939.66342 | 37.7779160412781 | -122.507232952822 | (37.7779160412781, -122.507232952822) | 11 | 6 | 2 | 55 | 26 | |||
39402 | 118643 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 486 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5981936.1877 | 2112495.85857 | 37.7794629495605 | -122.506113304335 | (37.7794629495605, -122.506113304335) | 11 | 6 | 2 | 55 | 26 | |||
158535 | 118644 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 486 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5981937.42716 | 2112478.07917 | 37.7794142055364 | -122.506107697947 | (37.7794142055364, -122.506107697947) | 11 | 6 | 2 | 55 | 26 | |||
77757 | 118572 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 7940 Geary Blvd | 2 | Back Yard : Yard | Tree | Private 2 | 6 | 5982338.13373 | 2112440.49418 | 37.7793345882457 | -122.50471872286 | (37.7793345882457, -122.50471872286) | 11 | 6 | 2 | 55 | 26 | ||||
16621 | 70332 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 765 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982891.42605 | 2110581.736 | 37.7742635126433 | -122.502667063271 | (37.7742635126433, -122.502667063271) | 11 | 6 | 2 | 55 | 26 | |||
166269 | 49712 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 579@ ANZA 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | 6 | Permit Number 46524 | 5983155.3096 | 2111876.05015 | 37.7778328268149 | -122.501850041932 | (37.7778328268149, -122.501850041932) | 11 | 6 | 2 | 55 | 26 | ||
149682 | 117781 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 563 40th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 5983463.79311 | 2111964.41208 | 37.7780935589435 | -122.500789443294 | (37.7780935589435, -122.500789443294) | 11 | 6 | 2 | 55 | 26 | |||
176619 | 117904 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 565 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5983773.51116 | 2111967.41814 | 37.7781199915327 | -122.499718256214 | (37.7781199915327, -122.499718256214) | 11 | 6 | 2 | 55 | 26 | |||
6000 | 73609 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 583 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983776.7045 | 2111867.80576 | 37.7778466722362 | -122.499699845252 | (37.7778466722362, -122.499699845252) | 11 | 6 | 2 | 55 | 26 | |||
3929 | 71612 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 583 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5983777.48185 | 2111850.0463 | 37.7777979555268 | -122.499695843243 | (37.7777979555268, -122.499695843243) | 11 | 6 | 2 | 55 | 26 | |||
4791 | 71991 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 785 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5984443.61146 | 2110542.72626 | 37.774247495924 | -122.497294973483 | (37.774247495924, -122.497294973483) | 11 | 6 | 2 | 55 | 26 | |||
14743 | 62600 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 775 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 13 | Permit Number 22906 | 5984443.81379 | 2110567.09676 | 37.7743144221812 | -122.497296073019 | (37.7743144221812, -122.497296073019) | 11 | 6 | 2 | 55 | 26 | |
12746 | 62599 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 769 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 15 | Permit Number 22905 | 5984445.13215 | 2110599.07692 | 37.774402307788 | -122.497293873927 | (37.774402307788, -122.497293873927) | 11 | 6 | 2 | 55 | 26 | |
94139 | 118215 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 698 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 5984468.62519 | 2111151.00765 | 37.7759191278138 | -122.49725335992 | (37.7759191278138, -122.49725335992) | 11 | 6 | 2 | 55 | 26 | |||
49597 | 118216 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 698 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 5984469.24074 | 2111130.26802 | 37.7758622188327 | -122.497249699274 | (37.7758622188327, -122.497249699274) | 11 | 6 | 2 | 55 | 26 | |||
723 | 62606 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 818 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 11 | Permit Number 22914 | 5984501.0298 | 2110256.07846 | 37.7734638082368 | -122.497075193473 | (37.7734638082368, -122.497075193473) | 11 | 6 | 2 | 55 | 26 | |
132202 | 50790 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3428 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2004 12:00:00 AM | 8 | Permit Number 47315 | 5984917.22998 | 2111122.72011 | 37.7758677393918 | -122.495699455942 | (37.7758677393918, -122.495699455942) | 11 | 6 | 2 | 55 | 26 | ||
16428 | 60560 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 563 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 15 | Permit Number 20170 | 5985010.58842 | 2112038.59041 | 37.7783879229396 | -122.495444072976 | (37.7783879229396, -122.495444072976) | 11 | 6 | 2 | 55 | 26 | |
13045 | 60561 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 623 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 13 | Permit Number 20171 | 5985027.19418 | 2111588.97397 | 37.7771543777649 | -122.495353460829 | (37.7771543777649, -122.495353460829) | 11 | 6 | 2 | 55 | 26 | |
8121 | 60537 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 543 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 11 | Permit Number 20147 | 5985322.70304 | 2112176.441 | 37.7787846915609 | -122.494374531621 | (37.7787846915609, -122.494374531621) | 11 | 6 | 2 | 55 | 26 | |
121728 | 119461 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 734 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5985720.75354 | 2110880.93237 | 37.7752508816345 | -122.492902087766 | (37.7752508816345, -122.492902087766) | 11 | 6 | 2 | 55 | 26 | |||
139997 | 119459 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 738 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5985721.52865 | 2110838.24141 | 37.7751337097391 | -122.492896261291 | (37.7751337097391, -122.492896261291) | 11 | 6 | 2 | 55 | 26 | |||
15455 | 119460 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 738 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5985722.56634 | 2110851.82305 | 37.7751710617394 | -122.492893672358 | (37.7751710617394, -122.492893672358) | 11 | 6 | 2 | 55 | 26 | |||
163733 | 99848 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 754 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6x9 | 5985724.77782 | 2110753.56839 | 37.7749014117299 | -122.492878783679 | (37.7749014117299, -122.492878783679) | 11 | 6 | 2 | 55 | 26 | |||
7084 | 119456 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 766 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5985728.91492 | 2110666.6398 | 37.7746629724789 | -122.492858068519 | (37.7746629724789, -122.492858068519) | 11 | 6 | 2 | 55 | 26 | |||
35733 | 119362 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 774 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5986039.00884 | 2110644.38527 | 37.7746199965829 | -122.491783767892 | (37.7746199965829, -122.491783767892) | 11 | 6 | 2 | 55 | 26 | |||
119937 | 119363 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 778 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5986041.46403 | 2110599.77221 | 37.7744976452717 | -122.491771990062 | (37.7744976452717, -122.491771990062) | 11 | 6 | 2 | 55 | 26 | |||
67393 | 24678 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 6800X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5986197.04198 | 2112576.81789 | 37.7799351415683 | -122.49137936882 | (37.7799351415683, -122.49137936882) | 11 | 6 | 2 | 55 | 26 | |||
86751 | 116402 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5986229.08474 | 2112614.12185 | 37.7800394399193 | -122.491271266446 | (37.7800394399193, -122.491271266446) | 11 | 6 | 2 | 55 | 26 | |||
4826 | 116397 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5986229.08994 | 2112682.60062 | 37.7802274633353 | -122.491276289815 | (37.7802274633353, -122.491276289815) | 11 | 6 | 2 | 55 | 26 | |||
104465 | 116400 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5986230.29228 | 2112656.5149 | 37.7801559096657 | -122.491270210016 | (37.7801559096657, -122.491270210016) | 11 | 6 | 2 | 55 | 26 | |||
147112 | 116399 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5986233.04111 | 2112658.12247 | 37.7801604842099 | -122.491260819038 | (37.7801604842099, -122.491260819038) | 11 | 6 | 2 | 55 | 26 | |||
127121 | 116401 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5986237.64962 | 2112628.59721 | 37.78007968557 | -122.491242702725 | (37.78007968557, -122.491242702725) | 11 | 6 | 2 | 55 | 26 | |||
135216 | 119394 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 5986270.74775 | 2112760.12891 | 37.7804427678726 | -122.491137885503 | (37.7804427678726, -122.491137885503) | 11 | 6 | 2 | 55 | 26 | |||
85264 | 119570 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 327 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5986502.90514 | 2113744.43466 | 37.7831589512032 | -122.490407187749 | (37.7831589512032, -122.490407187749) | 11 | 6 | 2 | 55 | 26 | |||
70532 | 119583 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 447 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5986530.76566 | 2112922.92614 | 37.7809049512588 | -122.490250352666 | (37.7809049512588, -122.490250352666) | 11 | 6 | 2 | 55 | 26 | |||
148511 | 119585 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5986541.41505 | 2112675.81312 | 37.7802270714189 | -122.490195329078 | (37.7802270714189, -122.490195329078) | 11 | 6 | 2 | 55 | 26 | |||
70781 | 119586 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5986542.60326 | 2112660.45173 | 37.7801849628176 | -122.490190088289 | (37.7801849628176, -122.490190088289) | 11 | 6 | 2 | 55 | 26 | |||
26168 | 119939 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2818 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5986800.01885 | 2111190.97243 | 37.7761652193503 | -122.48919151296 | (37.7761652193503, -122.48919151296) | 11 | 6 | 2 | 55 | 26 | |||
94882 | 40337 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2818 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 11 | Permit Number 41468 | 5986824.19116 | 2111191.52788 | 37.776168155372 | -122.489107936372 | (37.776168155372, -122.489107936372) | 11 | 6 | 2 | 55 | 26 | ||
16059 | 116635 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 527 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5986861.75763 | 2112332.8885 | 37.7793042006604 | -122.489061913888 | (37.7793042006604, -122.489061913888) | 11 | 6 | 2 | 55 | 26 | |||
192404 | 119927 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3618 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5987430.85621 | 2111895.98827 | 37.7781377959569 | -122.487061094459 | (37.7781377959569, -122.487061094459) | 11 | 6 | 2 | 55 | 26 | |||
62579 | 120048 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 363 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5987438.18349 | 2113514.39277 | 37.7825819029933 | -122.487154643236 | (37.7825819029933, -122.487154643236) | 11 | 6 | 2 | 55 | 26 | |||
56320 | 117102 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 328 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5987477.86636 | 2113711.99027 | 37.7831267633018 | -122.487031875861 | (37.7831267633018, -122.487031875861) | 11 | 6 | 2 | 55 | 26 | |||
193798 | 120076 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 139 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987696.52329 | 2115044.25708 | 37.786797534515 | -122.486373264348 | (37.786797534515, -122.486373264348) | 11 | 6 | 1 | 55 | 33 | |||
105435 | 34640 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 151 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38320 | 5987698.16294 | 2114953.08342 | 37.7865472933137 | -122.486360895433 | (37.7865472933137, -122.486360895433) | 11 | 6 | 1 | 55 | 33 | ||
58396 | 120175 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5987734.5845 | 2115254.5209 | 37.7873770771644 | -122.486257025031 | (37.7873770771644, -122.486257025031) | 11 | 6 | 1 | 55 | 33 | |||
60533 | 120176 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987736.19822 | 2115226.27808 | 37.7872996245264 | -122.486249367793 | (37.7872996245264, -122.486249367793) | 11 | 6 | 1 | 55 | 33 | |||
113357 | 64239 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/1988 12:00:00 AM | 6 | Permit Number 25032 | 5987737.4253 | 2115200.68824 | 37.7872294336752 | -122.486243243081 | (37.7872294336752, -122.486243243081) | 11 | 6 | 1 | 55 | 33 | ||
144652 | 120180 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 142 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987741.4363 | 2115024.74027 | 37.7867465647012 | -122.486216444552 | (37.7867465647012, -122.486216444552) | 11 | 6 | 1 | 55 | 33 | |||
45923 | 120385 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 259 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5987758.22769 | 2115294.71339 | 37.7874888122176 | -122.486178177201 | (37.7874888122176, -122.486178177201) | 11 | 6 | 1 | 55 | 33 | |||
56704 | 56605 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2435 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5987903.95793 | 2113257.39124 | 37.7819033981375 | -122.485524418369 | (37.7819033981375, -122.485524418369) | 11 | 6 | 2 | 55 | 26 | ||||
121159 | 93142 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2435 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5987916.65969 | 2113258.35358 | 37.7819067804793 | -122.485480547348 | (37.7819067804793, -122.485480547348) | 11 | 6 | 2 | 55 | 26 | |||
175246 | 34264 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 184 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | 2 | Permit Number 38068 | 5988062.8335 | 2114793.61342 | 37.7861306830116 | -122.485087536204 | (37.7861306830116, -122.485087536204) | 11 | 6 | 1 | 55 | 33 | |
65010 | 115470 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 178 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x4 | 5988064.27485 | 2114826.41599 | 37.7862208334715 | -122.48508495717 | (37.7862208334715, -122.48508495717) | 11 | 6 | 1 | 55 | 33 | |||
1426 | 84231 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 178 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988065.20329 | 2114809.31405 | 37.7861739305031 | -122.48508048983 | (37.7861739305031, -122.48508048983) | 11 | 6 | 1 | 55 | 33 | |||
176064 | 34266 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 190 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | 2 | Permit Number 38069 | 5988065.55649 | 2114756.40704 | 37.7860286835145 | -122.485075384697 | (37.7860286835145, -122.485075384697) | 11 | 6 | 1 | 55 | 33 | |
38344 | 34265 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 190 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | 4 | Permit Number 38069 | 5988067.01852 | 2114738.37532 | 37.7859792587146 | -122.48506900308 | (37.7859792587146, -122.48506900308) | 11 | 6 | 1 | 55 | 33 | |
109751 | 100363 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 327 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5988363.5301 | 2113726.92065 | 37.7832193582839 | -122.483968971104 | (37.7832193582839, -122.483968971104) | 11 | 6 | 2 | 55 | 26 | |||
156140 | 120464 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 75 West Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5988508.84723 | 2115012.16639 | 37.78675673738 | -122.483560494571 | (37.78675673738, -122.483560494571) | 11 | 6 | 1 | 55 | 33 | |||
62187 | 120463 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 75 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988518.34055 | 2115009.8271 | 37.7867508669083 | -122.483527478764 | (37.7867508669083, -122.483527478764) | 11 | 6 | 1 | 55 | 33 | |||
100308 | 96950 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 798X 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5988523.07232 | 2110612.50186 | 37.7746773247528 | -122.483188665707 | (37.7746773247528, -122.483188665707) | 11 | 6 | 2 | 55 | 26 | |||
174809 | 120462 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 75 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988526.89995 | 2115008.45783 | 37.7867476054693 | -122.483497765205 | (37.7867476054693, -122.483497765205) | 11 | 6 | 1 | 55 | 33 | |||
50802 | 120461 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 75 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988535.90114 | 2115005.41613 | 37.786739777719 | -122.483466400527 | (37.786739777719, -122.483466400527) | 11 | 6 | 1 | 55 | 33 | |||
50228 | 51475 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 123 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 47787 | 5988643.83675 | 2114504.19109 | 37.7853698375455 | -122.483056222564 | (37.7853698375455, -122.483056222564) | 11 | 6 | 2 | 55 | 26 | |||
158716 | 120398 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 119 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5988644.09739 | 2114516.48942 | 37.7854036204391 | -122.483056222561 | (37.7854036204391, -122.483056222561) | 11 | 6 | 2 | 55 | 26 | |||
33034 | 47768 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 135 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2002 12:00:00 AM | 6 | Permit Number 45546 | 5988647.58226 | 2114424.84716 | 37.785152199557 | -122.483037446886 | (37.785152199557, -122.483037446886) | 11 | 6 | 2 | 55 | 26 | ||
48167 | 120399 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 139 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5988648.94267 | 2114392.41964 | 37.7850632419385 | -122.483030362777 | (37.7850632419385, -122.483030362777) | 11 | 6 | 2 | 55 | 26 | |||
6741 | 120401 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 173 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5988655.68624 | 2114206.04007 | 37.7845518888292 | -122.482993367442 | (37.7845518888292, -122.482993367442) | 11 | 6 | 2 | 55 | 26 | |||
182494 | 34869 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 473 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/1997 12:00:00 AM | 8 | 4.5x6 | Permit Number 38484 | 5988730.29097 | 2112092.88451 | 37.7787540992695 | -122.482580364306 | (37.7787540992695, -122.482580364306) | 11 | 6 | 2 | 55 | 26 | |
88942 | 67949 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 10 | Permit Number 31663 | 5988821.45585 | 2110873.72112 | 37.7754119198865 | -122.482175650827 | (37.7754119198865, -122.482175650827) | 11 | 6 | 2 | 55 | 26 | |
8227 | 120322 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650 23rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5988821.62524 | 2110892.0885 | 37.7754623614562 | -122.482176410805 | (37.7754623614562, -122.482176410805) | 11 | 6 | 2 | 55 | 26 | |||
73893 | 454 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 740X 23rd Ave | 13 | Median : Cutout | Tree | DPW 1 | 12 | 8-HOA | 5988822.54016 | 2110230.27386 | 37.7736452554339 | -122.482124750469 | (37.7736452554339, -122.482124750469) | 11 | 6 | 2 | 55 | 26 | |||
135005 | 453 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 740X 23rd Ave | 14 | Median : Cutout | Tree | DPW 1 | 12 | 5988823.17752 | 2110218.88788 | 37.7736140297597 | -122.482121711467 | (37.7736140297597, -122.482121711467) | 11 | 6 | 2 | 55 | 26 | ||||
34898 | 65104 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 179 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 12 | Permit Number 27071 | 5988966.04699 | 2114149.58894 | 37.7844149444345 | -122.481915500518 | (37.7844149444345, -122.481915500518) | 11 | 6 | 2 | 55 | 26 | |
16358 | 120437 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 195 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5988969.68171 | 2114084.65341 | 37.7842368611834 | -122.481898167514 | (37.7842368611834, -122.481898167514) | 11 | 6 | 2 | 55 | 26 | |||
32944 | 65094 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 195 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 9 | Permit Number 27059 | 5988970.35279 | 2114105.07086 | 37.7842929607651 | -122.481897341966 | (37.7842929607651, -122.481897341966) | 11 | 6 | 2 | 55 | 26 | |
170964 | 103268 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2122 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988974.39725 | 2110591.0531 | 37.7746446865204 | -122.481625889052 | (37.7746446865204, -122.481625889052) | 11 | 6 | 2 | 55 | 26 | |||
4173 | 73353 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2121 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5988988.09253 | 2110533.92881 | 37.7744886354086 | -122.481574330241 | (37.7744886354086, -122.481574330241) | 11 | 6 | 2 | 55 | 26 | |||
96962 | 65107 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 182 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 4 | Permit Number 27074 | 5989016.12351 | 2114112.182 | 37.7843151476898 | -122.481739514245 | (37.7843151476898, -122.481739514245) | 11 | 6 | 2 | 55 | 26 | |
101606 | 120693 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 198 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989017.97681 | 2114064.75312 | 37.7841850291401 | -122.481729627408 | (37.7841850291401, -122.481729627408) | 11 | 6 | 2 | 55 | 26 | |||
192639 | 67944 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 755 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 13 | Permit Number 31658 | 5989111.58697 | 2110178.85549 | 37.7735208823708 | -122.481121139176 | (37.7735208823708, -122.481121139176) | 11 | 6 | 2 | 55 | 26 | |
156530 | 67946 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 767 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31660 | 5989111.82964 | 2110104.21091 | 37.7733159430986 | -122.481114832992 | (37.7733159430986, -122.481114832992) | 11 | 6 | 2 | 55 | 26 | |
66896 | 67945 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 759 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31659 | 5989112.06569 | 2110153.62937 | 37.7734516462501 | -122.481117635738 | (37.7734516462501, -122.481117635738) | 11 | 6 | 2 | 55 | 26 | |
193802 | 68946 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 763 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 11 | Permit Number 32935 | 5989112.30351 | 2110126.59265 | 37.7733774247171 | -122.481114833001 | (37.7733774247171, -122.481114833001) | 11 | 6 | 2 | 55 | 26 | |
103977 | 62986 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2033 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1986 12:00:00 AM | 11 | Permit Number 23382 | 5989156.23529 | 2113309.80659 | 37.7821201972679 | -122.481196007463 | (37.7821201972679, -122.481196007463) | 11 | 6 | 2 | 55 | 26 | ||
177968 | 120788 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 415 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5989337.08046 | 2112514.31643 | 37.7799465157752 | -122.480512123625 | (37.7799465157752, -122.480512123625) | 11 | 6 | 2 | 55 | 26 | |||
161662 | 120787 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 405 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5989337.13605 | 2112535.89775 | 37.7800057752829 | -122.480513511529 | (37.7800057752829, -122.480513511529) | 11 | 6 | 2 | 55 | 26 | |||
94281 | 68338 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 405 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 13 | Permit Number 32155 | 5989337.77446 | 2112566.05998 | 37.7800886294426 | -122.480513511529 | (37.7800886294426, -122.480513511529) | 11 | 6 | 2 | 55 | 26 | |
161253 | 120789 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 415 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5989338.22024 | 2112492.31002 | 37.7798861585579 | -122.480506569329 | (37.7798861585579, -122.480506569329) | 11 | 6 | 2 | 55 | 26 | |||
37741 | 120724 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5989381.12441 | 2112515.5067 | 37.7799523434629 | -122.480359844827 | (37.7799523434629, -122.480359844827) | 11 | 6 | 2 | 55 | 26 |
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) );