Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
| 117443 | 117443 | 118688 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4645 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5981105.94918 | 2110928.3269599997 | 37.7751100630106 | -122.508868980798 | (37.7751100630106, -122.508868980798) | ||||
| 143172 | 143172 | 90957 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4645 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981126.99481 | 2110929.9331 | 37.7751157135635 | -122.50879629988701 | (37.7751157135635, -122.508796299887) | ||
| 74263 | 74263 | 119137 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 539 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981289.035630001 | 2112044.01015 | 37.778184190679 | -122.50831848869 | (37.778184190679, -122.50831848869) | |||
| 156187 | 156187 | 119139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 549 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981289.11687 | 2111973.6044900003 | 37.777990882347495 | -122.508312980233 | (37.7779908823475, -122.508312980233) | |||
| 180992 | 180992 | 67264 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 549 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 9 | Permit Number 30731 | 5981289.18602 | 2111977.44312 | 37.778001426165396 | -122.50831302603001 | (37.7780014261654, -122.50831302603) | |
| 73568 | 73568 | 119138 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 545 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5981290.11106 | 2111996.02979 | 37.77805251417829 | -122.50831120604799 | (37.7780525141783, -122.508311206048) | |||
| 186174 | 186174 | 118875 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 722 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981376.4784699995 | 2110796.96576 | 37.7747653270952 | -122.507923425807 | (37.7747653270952, -122.507923425807) | |||
| 182386 | 182386 | 56079 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 722 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1973 12:00:00 AM | 9 | Permit Number 12176 | 5981378.48876 | 2110785.71135 | 37.7747345442385 | -122.50791563652001 | (37.7747345442385, -122.50791563652) | ||
| 34355 | 34355 | 119129 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 559 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5981600.59908 | 2111939.66342 | 37.7779160412781 | -122.507232952822 | (37.7779160412781, -122.507232952822) | |||
| 185999 | 185999 | 118643 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 486 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5981936.1877 | 2112495.85857 | 37.7794629495605 | -122.506113304335 | (37.7794629495605, -122.506113304335) | |||
| 62852 | 62852 | 118644 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 486 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5981937.4271599995 | 2112478.0791700003 | 37.7794142055364 | -122.506107697947 | (37.7794142055364, -122.506107697947) | |||
| 47138 | 47138 | 118572 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7940 Geary Blvd | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982338.13373 | 2112440.49418 | 37.7793345882457 | -122.50471872286 | (37.7793345882457, -122.50471872286) | ||||
| 134165 | 134165 | 70332 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 765 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 7 | 5982891.42605 | 2110581.736 | 37.7742635126433 | -122.502667063271 | (37.7742635126433, -122.502667063271) | ||
| 47907 | 47907 | 49712 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 579@ ANZA 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | 6 | Permit Number 46524 | 5983155.3096 | 2111876.05015 | 37.7778328268149 | -122.50185004193199 | (37.7778328268149, -122.501850041932) | ||
| 156512 | 156512 | 117781 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 563 40th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5983463.79311 | 2111964.41208 | 37.7780935589435 | -122.500789443294 | (37.7780935589435, -122.500789443294) | |||
| 31205 | 31205 | 117904 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 565 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5983773.51116 | 2111967.41814 | 37.778119991532705 | -122.49971825621401 | (37.7781199915327, -122.499718256214) | |||
| 70749 | 70749 | 73609 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 583 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5983776.7045 | 2111867.80576 | 37.7778466722362 | -122.499699845252 | (37.7778466722362, -122.499699845252) | ||
| 68581 | 68581 | 71612 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 583 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 7 | 5983777.48185 | 2111850.0463 | 37.77779795552679 | -122.499695843243 | (37.7777979555268, -122.499695843243) | ||
| 58170 | 58170 | 71991 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 785 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 11 | 5984443.61146 | 2110542.72626 | 37.774247495924 | -122.49729497348301 | (37.774247495924, -122.497294973483) | ||
| 163080 | 163080 | 62600 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 775 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 13 | Permit Number 22906 | 5984443.81379 | 2110567.0967599996 | 37.7743144221812 | -122.49729607301902 | (37.7743144221812, -122.497296073019) | |
| 153872 | 153872 | 62599 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 769 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 15 | Permit Number 22905 | 5984445.13215 | 2110599.07692 | 37.774402307788 | -122.497293873927 | (37.774402307788, -122.497293873927) | |
| 174162 | 174162 | 118215 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 698 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5984468.62519 | 2111151.00765 | 37.7759191278138 | -122.49725335991998 | (37.7759191278138, -122.49725335992) | |||
| 179617 | 179617 | 118216 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 698 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 5984469.24074 | 2111130.2680200003 | 37.7758622188327 | -122.49724969927401 | (37.7758622188327, -122.497249699274) | |||
| 51588 | 51588 | 62606 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 818 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 11 | Permit Number 22914 | 5984501.0298 | 2110256.07846 | 37.7734638082368 | -122.497075193473 | (37.7734638082368, -122.497075193473) | |
| 136423 | 136423 | 50790 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3428 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | 8 | Permit Number 47315 | 5984917.22998 | 2111122.7201099996 | 37.7758677393918 | -122.495699455942 | (37.7758677393918, -122.495699455942) | ||
| 66363 | 66363 | 60560 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 563 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 15 | Permit Number 20170 | 5985010.58842 | 2112038.5904099997 | 37.7783879229396 | -122.495444072976 | (37.7783879229396, -122.495444072976) | |
| 131073 | 131073 | 60561 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 13 | Permit Number 20171 | 5985027.194180001 | 2111588.97397 | 37.777154377764894 | -122.495353460829 | (37.7771543777649, -122.495353460829) | |
| 176033 | 176033 | 60537 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 543 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 11 | Permit Number 20147 | 5985322.70304 | 2112176.441 | 37.7787846915609 | -122.49437453162099 | (37.7787846915609, -122.494374531621) | |
| 54970 | 54970 | 119461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 734 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5985720.75354 | 2110880.93237 | 37.7752508816345 | -122.492902087766 | (37.7752508816345, -122.492902087766) | |||
| 155321 | 155321 | 119459 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 738 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5985721.52865 | 2110838.24141 | 37.7751337097391 | -122.49289626129101 | (37.7751337097391, -122.492896261291) | |||
| 69996 | 69996 | 119460 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 738 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5985722.56634 | 2110851.82305 | 37.7751710617394 | -122.492893672358 | (37.7751710617394, -122.492893672358) | |||
| 137426 | 137426 | 99848 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 754 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x9 | 5985724.7778199995 | 2110753.56839 | 37.7749014117299 | -122.492878783679 | (37.7749014117299, -122.492878783679) | |||
| 39619 | 39619 | 119456 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 766 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985728.914919999 | 2110666.6398 | 37.7746629724789 | -122.492858068519 | (37.7746629724789, -122.492858068519) | |||
| 183094 | 183094 | 119362 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 774 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5986039.00884 | 2110644.38527 | 37.7746199965829 | -122.491783767892 | (37.7746199965829, -122.491783767892) | |||
| 175486 | 175486 | 119363 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 778 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5986041.46403 | 2110599.7722099996 | 37.7744976452717 | -122.491771990062 | (37.7744976452717, -122.491771990062) | |||
| 89055 | 89055 | 24678 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 6800X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5986197.04198 | 2112576.81789 | 37.779935141568295 | -122.49137936882 | (37.7799351415683, -122.49137936882) | |||
| 181792 | 181792 | 116402 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 31st Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5986229.08474 | 2112614.12185 | 37.78003943991929 | -122.491271266446 | (37.7800394399193, -122.491271266446) | |||
| 72544 | 72544 | 116397 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5986229.08994 | 2112682.60062 | 37.780227463335294 | -122.491276289815 | (37.7802274633353, -122.491276289815) | |||
| 23607 | 23607 | 116400 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 31st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5986230.292280001 | 2112656.5149 | 37.7801559096657 | -122.491270210016 | (37.7801559096657, -122.491270210016) | |||
| 161506 | 161506 | 116399 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5986233.04111 | 2112658.1224700003 | 37.7801604842099 | -122.49126081903799 | (37.7801604842099, -122.491260819038) | |||
| 179552 | 179552 | 116401 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 31st Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5986237.649619999 | 2112628.59721 | 37.78007968557 | -122.49124270272499 | (37.78007968557, -122.491242702725) | |||
| 37519 | 37519 | 119394 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 31st Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5986270.74775 | 2112760.12891 | 37.7804427678726 | -122.49113788550301 | (37.7804427678726, -122.491137885503) | |||
| 135037 | 135037 | 119570 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 327 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5986502.90514 | 2113744.43466 | 37.783158951203205 | -122.490407187749 | (37.7831589512032, -122.490407187749) | |||
| 71284 | 71284 | 119583 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 447 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5986530.76566 | 2112922.92614 | 37.7809049512588 | -122.490250352666 | (37.7809049512588, -122.490250352666) | |||
| 33414 | 33414 | 119585 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5986541.41505 | 2112675.81312 | 37.7802270714189 | -122.490195329078 | (37.7802270714189, -122.490195329078) | |||
| 31278 | 31278 | 119586 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5986542.60326 | 2112660.45173 | 37.7801849628176 | -122.490190088289 | (37.7801849628176, -122.490190088289) | |||
| 184808 | 184808 | 119939 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2818 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5986800.01885 | 2111190.97243 | 37.7761652193503 | -122.48919151296002 | (37.7761652193503, -122.48919151296) | |||
| 161166 | 161166 | 40337 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2818 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 11 | Permit Number 41468 | 5986824.19116 | 2111191.52788 | 37.776168155372 | -122.489107936372 | (37.776168155372, -122.489107936372) | ||
| 141766 | 141766 | 116635 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 527 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5986861.75763 | 2112332.8885 | 37.7793042006604 | -122.489061913888 | (37.7793042006604, -122.489061913888) | |||
| 183823 | 183823 | 119927 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3618 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5987430.85621 | 2111895.98827 | 37.778137795956894 | -122.487061094459 | (37.7781377959569, -122.487061094459) | |||
| 57220 | 57220 | 120048 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 363 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5987438.18349 | 2113514.3927700003 | 37.7825819029933 | -122.48715464323601 | (37.7825819029933, -122.487154643236) | |||
| 24267 | 24267 | 117102 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 328 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987477.866359999 | 2113711.99027 | 37.783126763301794 | -122.48703187586099 | (37.7831267633018, -122.487031875861) | |||
| 29836 | 29836 | 120076 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 139 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987696.52329 | 2115044.25708 | 37.786797534515 | -122.48637326434799 | (37.786797534515, -122.486373264348) | |||
| 67683 | 67683 | 34640 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 151 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38320 | 5987698.16294 | 2114953.08342 | 37.7865472933137 | -122.48636089543301 | (37.7865472933137, -122.486360895433) | ||
| 40912 | 40912 | 120175 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5987734.5845 | 2115254.5209 | 37.7873770771644 | -122.486257025031 | (37.7873770771644, -122.486257025031) | |||
| 70681 | 70681 | 120176 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987736.19822 | 2115226.27808 | 37.7872996245264 | -122.48624936779301 | (37.7872996245264, -122.486249367793) | |||
| 187079 | 187079 | 64239 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/1988 12:00:00 AM | 6 | Permit Number 25032 | 5987737.4253 | 2115200.68824 | 37.7872294336752 | -122.48624324308099 | (37.7872294336752, -122.486243243081) | ||
| 54145 | 54145 | 120180 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 142 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5987741.4363 | 2115024.74027 | 37.786746564701204 | -122.486216444552 | (37.7867465647012, -122.486216444552) | |||
| 185232 | 185232 | 120385 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 259 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5987758.22769 | 2115294.71339 | 37.7874888122176 | -122.486178177201 | (37.7874888122176, -122.486178177201) | |||
| 112379 | 112379 | 56605 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2435 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5987903.9579300005 | 2113257.3912400003 | 37.7819033981375 | -122.48552441836901 | (37.7819033981375, -122.485524418369) | ||||
| 139380 | 139380 | 93142 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2435 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5987916.65969 | 2113258.35358 | 37.7819067804793 | -122.485480547348 | (37.7819067804793, -122.485480547348) | |||
| 149176 | 149176 | 34264 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 184 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 2 | Permit Number 38068 | 5988062.8335 | 2114793.6134200003 | 37.786130683011606 | -122.48508753620399 | (37.7861306830116, -122.485087536204) | |
| 75703 | 75703 | 115470 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 178 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x4 | 5988064.27485 | 2114826.41599 | 37.786220833471496 | -122.48508495716999 | (37.7862208334715, -122.48508495717) | |||
| 176593 | 176593 | 84231 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 178 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988065.203290001 | 2114809.31405 | 37.786173930503104 | -122.48508048983 | (37.7861739305031, -122.48508048983) | ||
| 153920 | 153920 | 34266 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 2 | Permit Number 38069 | 5988065.55649 | 2114756.40704 | 37.7860286835145 | -122.485075384697 | (37.7860286835145, -122.485075384697) | |
| 160093 | 160093 | 34265 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 4 | Permit Number 38069 | 5988067.018519999 | 2114738.37532 | 37.7859792587146 | -122.48506900308 | (37.7859792587146, -122.48506900308) | |
| 157329 | 157329 | 100363 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 327 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5988363.5301 | 2113726.92065 | 37.783219358283894 | -122.48396897110399 | (37.7832193582839, -122.483968971104) | |||
| 36609 | 36609 | 120464 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 75 West Clay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5988508.84723 | 2115012.1663900004 | 37.786756737379996 | -122.483560494571 | (37.78675673738, -122.483560494571) | |||
| 60088 | 60088 | 120463 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 75 West Clay St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988518.34055 | 2115009.8271 | 37.7867508669083 | -122.483527478764 | (37.7867508669083, -122.483527478764) | |||
| 125548 | 125548 | 96950 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 798X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5988523.072319999 | 2110612.5018599997 | 37.7746773247528 | -122.48318866570699 | (37.7746773247528, -122.483188665707) | |||
| 27215 | 27215 | 120462 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 75 West Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988526.89995 | 2115008.4578299997 | 37.7867476054693 | -122.483497765205 | (37.7867476054693, -122.483497765205) | |||
| 164973 | 164973 | 120461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 75 West Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988535.90114 | 2115005.41613 | 37.786739777719 | -122.483466400527 | (37.786739777719, -122.483466400527) | |||
| 186107 | 186107 | 51475 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 123 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 47787 | 5988643.83675 | 2114504.1910900003 | 37.7853698375455 | -122.48305622256399 | (37.7853698375455, -122.483056222564) | |||
| 153406 | 153406 | 120398 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 119 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5988644.09739 | 2114516.48942 | 37.7854036204391 | -122.483056222561 | (37.7854036204391, -122.483056222561) | |||
| 67178 | 67178 | 47768 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 135 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2002 12:00:00 AM | 6 | Permit Number 45546 | 5988647.58226 | 2114424.84716 | 37.785152199557 | -122.483037446886 | (37.785152199557, -122.483037446886) | ||
| 132187 | 132187 | 120399 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 139 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5988648.94267 | 2114392.41964 | 37.7850632419385 | -122.483030362777 | (37.7850632419385, -122.483030362777) | |||
| 61755 | 61755 | 120401 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 173 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988655.68624 | 2114206.04007 | 37.7845518888292 | -122.48299336744199 | (37.7845518888292, -122.482993367442) | |||
| 45264 | 45264 | 34869 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 473 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/1997 12:00:00 AM | 8 | 4.5x6 | Permit Number 38484 | 5988730.2909699995 | 2112092.88451 | 37.7787540992695 | -122.48258036430599 | (37.7787540992695, -122.482580364306) | |
| 162296 | 162296 | 67949 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 10 | Permit Number 31663 | 5988821.45585 | 2110873.72112 | 37.7754119198865 | -122.482175650827 | (37.7754119198865, -122.482175650827) | |
| 185622 | 185622 | 120322 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 23rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5988821.62524 | 2110892.0885 | 37.775462361456206 | -122.482176410805 | (37.7754623614562, -122.482176410805) | |||
| 86980 | 86980 | 454 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988822.540159999 | 2110230.27386 | 37.7736452554339 | -122.482124750469 | (37.7736452554339, -122.482124750469) | |||
| 116178 | 116178 | 453 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988823.177519999 | 2110218.88788 | 37.773614029759706 | -122.482121711467 | (37.7736140297597, -122.482121711467) | ||||
| 29163 | 29163 | 65104 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 179 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 12 | Permit Number 27071 | 5988966.04699 | 2114149.58894 | 37.7844149444345 | -122.481915500518 | (37.7844149444345, -122.481915500518) | |
| 55126 | 55126 | 120437 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 195 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5988969.68171 | 2114084.65341 | 37.7842368611834 | -122.481898167514 | (37.7842368611834, -122.481898167514) | |||
| 65497 | 65497 | 65094 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 195 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | 9 | Permit Number 27059 | 5988970.35279 | 2114105.07086 | 37.7842929607651 | -122.481897341966 | (37.7842929607651, -122.481897341966) | |
| 132485 | 132485 | 103268 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2122 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988974.39725 | 2110591.0531 | 37.7746446865204 | -122.481625889052 | (37.7746446865204, -122.481625889052) | |||
| 163574 | 163574 | 73353 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2121 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 9 | 5988988.09253 | 2110533.92881 | 37.7744886354086 | -122.48157433024099 | (37.7744886354086, -122.481574330241) | ||
| 30848 | 30848 | 65107 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 182 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 4 | Permit Number 27074 | 5989016.12351 | 2114112.182 | 37.784315147689796 | -122.48173951424499 | (37.7843151476898, -122.481739514245) | |
| 151050 | 151050 | 120693 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 198 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989017.97681 | 2114064.75312 | 37.7841850291401 | -122.48172962740801 | (37.7841850291401, -122.481729627408) | |||
| 133197 | 133197 | 67944 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 755 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 13 | Permit Number 31658 | 5989111.58697 | 2110178.85549 | 37.773520882370796 | -122.48112113917601 | (37.7735208823708, -122.481121139176) | |
| 69992 | 69992 | 67946 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 767 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 12 | Permit Number 31660 | 5989111.82964 | 2110104.21091 | 37.7733159430986 | -122.481114832992 | (37.7733159430986, -122.481114832992) | |
| 131550 | 131550 | 67945 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 759 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 12 | Permit Number 31659 | 5989112.065690001 | 2110153.62937 | 37.7734516462501 | -122.48111763573799 | (37.7734516462501, -122.481117635738) | |
| 161811 | 161811 | 68946 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 763 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 11 | Permit Number 32935 | 5989112.30351 | 2110126.59265 | 37.773377424717104 | -122.481114833001 | (37.7733774247171, -122.481114833001) | |
| 68971 | 68971 | 62986 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2033 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1986 12:00:00 AM | 11 | Permit Number 23382 | 5989156.23529 | 2113309.80659 | 37.7821201972679 | -122.481196007463 | (37.7821201972679, -122.481196007463) | ||
| 187305 | 187305 | 120788 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 415 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5989337.08046 | 2112514.31643 | 37.7799465157752 | -122.48051212362499 | (37.7799465157752, -122.480512123625) | |||
| 58469 | 58469 | 120787 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 405 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5989337.13605 | 2112535.89775 | 37.780005775282895 | -122.48051351152901 | (37.7800057752829, -122.480513511529) | |||
| 154419 | 154419 | 68338 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 405 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 13 | Permit Number 32155 | 5989337.77446 | 2112566.05998 | 37.7800886294426 | -122.48051351152901 | (37.7800886294426, -122.480513511529) | |
| 168733 | 168733 | 120789 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 415 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5989338.22024 | 2112492.31002 | 37.77988615855789 | -122.480506569329 | (37.7798861585579, -122.480506569329) | |||
| 44926 | 44926 | 120724 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5989381.12441 | 2112515.5067 | 37.779952343462895 | -122.480359844827 | (37.7799523434629, -122.480359844827) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");